All Hokie, All the Time. Period. Presented by

The Lounge Board

HokieDevil

Joined: 05/01/2003 Posts: 10637
Likes: 2267

What's this?

Does the text or numbers have any commonality?


Like do all the letters have the same values for at least part of the fields? It's not elegant but if they do then you can do a find and replace for those letters. Just leave the replace field blank.

(In response to this post by Baltimore Hokie)

Posted: 12/12/2019 at 4:09PM


+0

Insert a Link

Enter the title of the link here:


Enter the full web address of the link here -- include the "http://" part:


75
Hide This

Current Thread:
 
  Excel question -- Baltimore Hokie 12/12/2019 3:38PM
  Use the delegate function. ** -- Guy LeDouche 12/12/2019 4:16PM
  Is that delegating the task to a subordinate? ** -- EDGEMAN 12/12/2019 4:21PM
  Does the text or numbers have any commonality? -- HokieDevil 12/12/2019 4:09PM
  =LEFT(RIGHT(A1,7),6) ** -- VTSnake 12/12/2019 3:59PM
  Or =MID(A1,2,6)** -- VTENGR 12/12/2019 4:25PM
  It works! ** -- VT Pez4Life 12/12/2019 4:12PM
  So the digits are inside parentheses? -- s.mill hokie 12/12/2019 3:47PM
  That did it, thank! ** -- Baltimore Hokie 12/12/2019 4:28PM
  Are all of the characters in the text string numbers? Basically you have.. -- EDGEMAN 12/12/2019 3:45PM
  Copy paste delete. Have fun ** -- HokieAl 12/12/2019 3:42PM

Tech Sideline is Presented By:

Our Sponsors







vm307